Forum Discussion
Helper VMonth sort difficulties when excluding year
Hey,
no you don't need to create an extra table.
Somehow there is a little glitch in your PeriodNbr column, the number 12 is assigned to May in the year 2016 and June in the year 2017. Have a closer look at the datetime may 2016, it's duplicate.
If you fix this the error will disappear.
Regards
Super UserHey,
just sort the column MonthName by the column PeriodNbr.
You can't use the column PeriodHistorySort because one MonthName eg July gets different sort values 01 and 14.
Regards
shaunwilksThanks for the suggestion but this returns the same error.
I have done this in another project where only 1 year of financial data was in the table and it works fine - so clearly the issue is because there are three of each month in the MonthName column and there are three of each PeriodNbr in that column.
I think the only solution will be to create another table that only stores the month name once and join the table to it using the PeriodNbr. Ultimately I dont think you should have to do this as the sort on the MonthName column in my example should be allowed by the PeriodNbr as you assumed - it just doesnt allow it.
- TomMartens
Hey,
no you don't need to create an extra table.
Somehow there is a little glitch in your PeriodNbr column, the number 12 is assigned to May in the year 2016 and June in the year 2017. Have a closer look at the datetime may 2016, it's duplicate.
If you fix this the error will disappear.
Regards